In this article, we look at a comparison of how to perform ETL tasks in an Oracle environment using ODI versus a SQL Server environment using SSIS.
Learn about exception handling in Python and how to catch and address various issues using try, except, else, and finally.
In this article, we look at how to create transactions when using Snowflake along with several commands specific to working with transactions.
In this article, we look at how to build a box and whisker plot chart using Power BI Desktop with a step-by-step walkthrough.
In this article, we will review the benefits and drawbacks of using database partitioning (sharding) to help improve performance and maintenance tasks.
Learn about how to implement a simple bucket sort algorithm using Python code to sort a list of array values.
This article provides some questions you may be asked and areas of discussion for an interview related to Power BI jobs.
The Spark engine supports several different file formats and in this article, we look at the pros and cons of each file type and which might be best to use.
In this article, we look at the basics of using SQL Server variables in T-SQL code to allow for more dynamic code creation.
Learn how to import data from an Excel file into a SQL Server database using Python.
Learn about Azure Synapse Link to replicate one or more tables from Azure SQL Database or SQL Server 2022 to a dedicated SQL Pool in an Azure Synapse Analytics workspace.
Auto-Create statistics is a well-known feature critical for the database performance. When one statistic is auto created, changing the table structure is not blocked by the presence of the statistic. An auto-created statistics is also dropped automatically when a schema change happens. On the other hand, if the statistic is created by the user, any …
The post SQL Server 2022: How Auto-Drop Statistics Work appeared first on Simple Talk.
Learn how to build a star schema data model using Power BI Desktop for improved report development and performance.
In this article, we look at how to enable auditing for an Azure SQL Managed Instance.
Learn how to use the CREATE OR ALTER statement in SQL Server to create an object if it does not already exist or alter an object if it does exist.
Learn about the different ways to capture and identify blocking that is occurring in SQL Server.
In this article, we look at how to do a point in time restore using TSQL and SSMS to recover a database to a particular point in time.
In this article, we look at different ways to check query syntax by using PARSEONLY, NOEXEC as well as executing the code to see how SQL Server handles each of these.
This article looks at how to calculate MACD indicators using a set of T-SQL code and data stored in a SQL Server database.
In this article, we look at various aspects of an ERD (entity relationship diagram) and how to put together an ERD for your database applications.
This tip will go through some guidelines for creating an optimized data model when working with Power BI for performance and accurate results.
In this article, we walk through the steps and examples of how to use Secure File Transfer Protocol (SFTP) when working in Azure.
In this article, we will look at how to add database code to a Visual Studio solution along with the application code.
Learn about SQL Server schemas in this overview tip that explains what they are, how to create, and creating objects in different schemas.
Learn about prepared statements in SQL Server, what they are, and how to use them along with the commands sp_prepare and sp_execute.
Learn about how SQL Server stores data on a data page and the amount of space that is used to store data with this in-depth example.
This tip illustrates how to correlate nominal and real Gross Domestic Product (GDP) with business indicators using T-SQL and Excel.
In this article, we look at ways to enforce data integrity when working with Delta Lake tables when using Azure Synapse Analytics. 
In this article we look at several different date and time formats you can use in SQL Server.
In this article, we look at constraints in Snowflake such as PRIMARY KEY, UNIQUE KEY, FOREIGN KEY, and NOT NULL and how they are enforced in Snowflake.
In this article, we do a comparison of Power BI and Tableau, and which tool may be a better choice for your report and dashboard development.
Learn how to use the Apache Spark ecosystem to filter and/or aggregate data stored in hive tables.
If you want to use cloud resources efficiently, learn how to make sure you fully address five main areas of cloud management: costs, regulations, resources, identity, and deployment automation.
This tip will show how to configure auto-failover groups for Azure SQL Database and Azure SQL Managed Instances for SQL Server.